UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rev8rR3gPwK60FN0dfu4726O+xPDZYrwdqpUpxwHmCw='
WHERE
key_id = '4386d1c47a9f860dec22f49f1530d3bbfde23c084beb010a2e4218aabdb4f70c'
AND (
token = 'rev8rR3gPwK60FN0dfu4726O+xPDZYrwdqpUpxwHmCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)