UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dhDj1EttHzxGBXHJc/5Y137PyrSAKEq/BAa4jVxdDU='
WHERE
key_id = 'f09741c955c4c1db78dd89a1dc63047fc8a82547f256b9636a2c2bc0a99a3c02'
AND (
token = '0dhDj1EttHzxGBXHJc/5Y137PyrSAKEq/BAa4jVxdDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)