UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHVJHoRTU+4S9AvHQYlnl/Wr/ZiOZ7JuSf/BuR0yKWU='
WHERE
key_id = 'fe1bda360250c3bb95dcbd511369d87be36b18dbfe5a7946a510f274baf92aa8'
AND (
token = 'xHVJHoRTU+4S9AvHQYlnl/Wr/ZiOZ7JuSf/BuR0yKWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)