UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dAQiBP0nVox4brBcSFSlgqY5gFBicg8tlQ0n13XOy1w='
WHERE
key_id = '2d4c86cf2bf37f94e14720342e3c875ea81b7509b1083d4af808bb0cf53e46a7'
AND (
token = 'dAQiBP0nVox4brBcSFSlgqY5gFBicg8tlQ0n13XOy1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)