UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'As7o6BI7eL8xECgggykepsGohNKYPd+iWYW8u6k8jy0='
WHERE
key_id = 'd5cd306f435b37d9390e7d81351b66e0f8411c54ea181cfc36c80f26e3c9cec7'
AND (
token = 'As7o6BI7eL8xECgggykepsGohNKYPd+iWYW8u6k8jy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)