UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K77uwDcgl966h3DbqOD7jIqjLCFMp5myBX7wq8GnbTU='
WHERE
key_id = '552d6df6e10dfae30dc446ea9cc409f87e48b0fa08203c1d9c25c3e6e5ec81ed'
AND (
token = 'K77uwDcgl966h3DbqOD7jIqjLCFMp5myBX7wq8GnbTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)