UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ro1C6y0nsKX0zTWZnhliieA1b17o+XKJmdY0JNw2xnI='
WHERE
key_id = '42d9f3687d8f1911a65f4d54a495d9d789954291722debcaa292b15271de7fe2'
AND (
token = 'ro1C6y0nsKX0zTWZnhliieA1b17o+XKJmdY0JNw2xnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)