UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ovvuCTR7QQXx8iIKMpxqelYnDaKQykwlI3w+Mmo7dM='
WHERE
key_id = '364a240ea80f66c5e39da4610d9f3192605f75cc183b073bc04e7a2ad5fb54cf'
AND (
token = '4ovvuCTR7QQXx8iIKMpxqelYnDaKQykwlI3w+Mmo7dM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)