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