UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SgpXfkltjV0vc9Hbk3WbIMSHvUuXgkl43b+ovbHXF7k='
WHERE
key_id = '4f04b7938e73f3ead42a73ff3178e12a497e9f9d3f8ce0a85cc6eeae0caff54f'
AND (
token = 'SgpXfkltjV0vc9Hbk3WbIMSHvUuXgkl43b+ovbHXF7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)