UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aZxZvZO7OHQQV1IdeWr7dak/XF76cOkfSVaEN9SF/8='
WHERE
key_id = 'bc1ea9d522fcc42d0468946d9d6f182abf95fefce884f4be9958f5d29d1d21ba'
AND (
token = '+aZxZvZO7OHQQV1IdeWr7dak/XF76cOkfSVaEN9SF/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)