UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KSBAXi6WpYRMmldR/JkiikuD8KQmsMUf0M32M9s8qfM='
WHERE
key_id = 'a00cdcdb5899a6efc127d82a1695cabcdfd4ac9c6fe04594eb071b1291cae975'
AND (
token = 'KSBAXi6WpYRMmldR/JkiikuD8KQmsMUf0M32M9s8qfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)