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