UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGwvuM6tpFmBdTZ1UfPYYCPaLWxuvxJ4prS2R2qJ1us='
WHERE
key_id = '2e2b019c46a22ea3f2083d7cbdb054ad4f1da2bb14f2e4c51bac11b7aefb7bf1'
AND (
token = 'XGwvuM6tpFmBdTZ1UfPYYCPaLWxuvxJ4prS2R2qJ1us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)