UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I4sdK4jL/vrMInY49XJVhccCZgWBcVTzIkTiQSZIonE='
WHERE
key_id = '6e27f61f9bc90d514aa839a47d833e6a6b646d7ea523c8883df6ad435bc9332c'
AND (
token = 'I4sdK4jL/vrMInY49XJVhccCZgWBcVTzIkTiQSZIonE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)