UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+IMcKdjzPW8uSsZaIv7af3e2C8l/jz62wPYbtWwrpw8='
WHERE
key_id = 'c11a30f2ee641fc02e45ad68c9a62f4db6f8064daaa5d8d3044e270df28acc3b'
AND (
token = '+IMcKdjzPW8uSsZaIv7af3e2C8l/jz62wPYbtWwrpw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)