UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ch0OYkXTnX/uxbsbdCanlYxb7nimqaxHtzMnAavxoG0='
WHERE
key_id = 'bfbe3f6b135902e4a18dea28cce9be165b2fe8ae7b9201cc0ae58f8cfe4e4ee6'
AND (
token = 'ch0OYkXTnX/uxbsbdCanlYxb7nimqaxHtzMnAavxoG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)