UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUoPbPAiWxAKeqF1F/5dM3d1zxTvjVPcCdaSrmpfIfA='
WHERE
key_id = 'd697f68fdca35370c1e47ffc70056aab21f1b0a63cc4a7aeb82663c6e0c39adf'
AND (
token = 'nUoPbPAiWxAKeqF1F/5dM3d1zxTvjVPcCdaSrmpfIfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)