UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/2WXdH3CIsbU19peMfLCJp4rmdLuMCf0EIa28pa1XxI='
WHERE
key_id = 'f9089f064b4363bc3dc614c54722321262fa1221e0974b038cabee01a7a25beb'
AND (
token = '/2WXdH3CIsbU19peMfLCJp4rmdLuMCf0EIa28pa1XxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)