UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P1ZXRQL97nnt0jx9ecrrwUBsAw5/oWXkpvFyxud/o04='
WHERE
key_id = 'ae4a668a4f8fdfb4fb1f0c04b166a2b647a740423777b5f0359130a8dc3d6c02'
AND (
token = 'P1ZXRQL97nnt0jx9ecrrwUBsAw5/oWXkpvFyxud/o04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)