UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pj3ZJI9500GRDj8YHpJM0GNirIcpPu5XGSFR0Cn/hic='
WHERE
key_id = 'e6ddee3987359ebe6db357c6b7087cb71b65a02ba865d3c1b6b57b3605ca8986'
AND (
token = 'pj3ZJI9500GRDj8YHpJM0GNirIcpPu5XGSFR0Cn/hic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)