UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sxPJU2l2dwqozgOwVZEXciI2jxNWEtw/nPYirJvekDk='
WHERE
key_id = '58fcc4b15c2a6ae582759a9308b810e0cde4a5c413de552aed101cdabb83876a'
AND (
token = 'sxPJU2l2dwqozgOwVZEXciI2jxNWEtw/nPYirJvekDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)