UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w7hznu34ICDq7hFGWfspKQp4yG2cshAjVe3Nims+/8s='
WHERE
key_id = 'a8eca564c641b2464ca6cc79b3c72d820853f29b11f5e47a968d1ba5d450344d'
AND (
token = 'w7hznu34ICDq7hFGWfspKQp4yG2cshAjVe3Nims+/8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)