UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XlyiN7RKJ3OSdJpQebWeegnuvxSxbXZkKyNc5niRTy4='
WHERE
key_id = '0aa8b0395632d8584e245e06e4de15ac98059c91ca53695033b37bccc0aacd16'
AND (
token = 'XlyiN7RKJ3OSdJpQebWeegnuvxSxbXZkKyNc5niRTy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)