UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKj0orFheUUiZQsK8IjAvGFDPZMRFqcdN16lXIjkvTU='
WHERE
key_id = '2ec43f2d8eefb2ff0b497281fcb0cbc3d4750408a1497d86a0ab0dc35e35ebe3'
AND (
token = 'KKj0orFheUUiZQsK8IjAvGFDPZMRFqcdN16lXIjkvTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)