UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1rWOXyFrPKFA5q9JBkKcUwEChai0RWwK4cooIMZc21c='
WHERE
key_id = '67b55d4bb48df63f46d813ce5b466385a9f942a3088cb322b38abb0389291b0a'
AND (
token = '1rWOXyFrPKFA5q9JBkKcUwEChai0RWwK4cooIMZc21c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)