UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/mIxMzxF1yaz+MxYgoVpcIkcyN0LKRtyzKcj4+6swiY='
WHERE
key_id = 'ddd1c29e70ae3cd6265d688326b1c34d119d241bd2d3522bda0d99e03b8484d3'
AND (
token = '/mIxMzxF1yaz+MxYgoVpcIkcyN0LKRtyzKcj4+6swiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)