UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nl7aaS1pUXysqsjP9CQPFML6bMh4PkoFT++Citdf++s='
WHERE
key_id = 'a1801713e408ebcb95d8237cece8ace1a555a80a5fcc89a379f10037c9c4385d'
AND (
token = 'Nl7aaS1pUXysqsjP9CQPFML6bMh4PkoFT++Citdf++s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)