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