UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SGG1H82cnpnwzVRH4R3P1YAj7fAo5xxC5DW9oxKy3XA='
WHERE
key_id = 'e3cb23f19d0c3c0ae928b86da7a5d960f6bc1bcee210a44ee729f09dfd6312fb'
AND (
token = 'SGG1H82cnpnwzVRH4R3P1YAj7fAo5xxC5DW9oxKy3XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)