UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0q5Xwut0TV+ujy6LFS8U7cOYpohDrRa61NuR/QrYvdo='
WHERE
key_id = 'cfdc491c2a8cbd967bf50b2b22aa62baebe0e23364f88592aac947bc610d1175'
AND (
token = '0q5Xwut0TV+ujy6LFS8U7cOYpohDrRa61NuR/QrYvdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)