UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oTooLX0RSdIACOgHLXFH7nvRC5ez2J5IeihcSEWKiw0='
WHERE
key_id = '47758999eb843c3b15e51d89eb07af7e9fd7cf8515fd6132a0cd11d236d51ed5'
AND (
token = 'oTooLX0RSdIACOgHLXFH7nvRC5ez2J5IeihcSEWKiw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)