UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hNrtYMyA9w3XMSXNwHfvqhU7pKgim0JcWYbZ/Hh1W6Y='
WHERE
key_id = '974bf07ee90e15d630617c676ba27d534c2c5ed2e2b6efb31915658f2ed82cce'
AND (
token = 'hNrtYMyA9w3XMSXNwHfvqhU7pKgim0JcWYbZ/Hh1W6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)