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