UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BFifcLwzI8Mg8vFvn1Ml8BzM0J8jecwVhxv9CCpiN/E='
WHERE
key_id = '97c41cdecb558217aa5f74f25659741ebeec23af4774c8e7fc056e1916fda517'
AND (
token = 'BFifcLwzI8Mg8vFvn1Ml8BzM0J8jecwVhxv9CCpiN/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)