UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZiaUcNSOYq17ee9RqwSXM1UIkMHyfNSEz8or4/WUcU='
WHERE
key_id = '9bfc73114930c48dd3408fa495190e6fd70f9443559176ef31ed71cf272dbb16'
AND (
token = 'dZiaUcNSOYq17ee9RqwSXM1UIkMHyfNSEz8or4/WUcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)