UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cEgjJQWNtQj6pdJrn0QFOnL7Pb8xWHTFW/MEHqadnxA='
WHERE
key_id = 'a9381a97a8b2321f662023274ad367b9df5fcee6e672fbc3524dd9f08f3d9561'
AND (
token = 'cEgjJQWNtQj6pdJrn0QFOnL7Pb8xWHTFW/MEHqadnxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)