UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Z/V59PghTwk7DAIaT6tm1FwkdW798SSYxhwRUn2UGc='
WHERE
key_id = '28efa969592c8b3d3b845d60d40572db1f96f2398a5b03e8eaa71d2b26663074'
AND (
token = '0Z/V59PghTwk7DAIaT6tm1FwkdW798SSYxhwRUn2UGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)