UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fzc1Zmh/+ibrt3GAcdP7NJV9f1osBC4eUS4nUaL2K1o='
WHERE
key_id = '87dee9f64eae06448d7d511725f4ff7eadbf97d7ebf7b86bbebd43e83cc867f1'
AND (
token = 'fzc1Zmh/+ibrt3GAcdP7NJV9f1osBC4eUS4nUaL2K1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)