UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1s38YbT3BVXmh0D/mbXLVQVThh3fxi3elFFA2HKLWuU='
WHERE
key_id = '5b504e181076cc24c6552cc5f88280cdbedaa7e7b1ef0d7c77e872c5aacbace5'
AND (
token = '1s38YbT3BVXmh0D/mbXLVQVThh3fxi3elFFA2HKLWuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)