UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0R8vjz7CGfz3z7i3jX+Res3xPkwsPFGKtgWn9RHHS+8='
WHERE
key_id = 'ff23f9b880047d81a6e7d650aaa42fbd76bead9087b960ebb2c9b1ae827545cf'
AND (
token = '0R8vjz7CGfz3z7i3jX+Res3xPkwsPFGKtgWn9RHHS+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)