UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T5Jc7PgelrIStcxYrDfWNJ4ju2KHUjKtc9HqnZdorUs='
WHERE
key_id = 'e194a55adc0f2a4a16b35325338e054a96df83c0c2d349a91e57555209f7d60f'
AND (
token = 'T5Jc7PgelrIStcxYrDfWNJ4ju2KHUjKtc9HqnZdorUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)