UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9AYRSVcWCMWT4kPoE9rGujapbmRfLQvO4hPIPicyMx0='
WHERE
key_id = 'd9068dbb62354fc34f1d4187c3f7f5b3f530b2a904f2e100c790b66d1746a494'
AND (
token = '9AYRSVcWCMWT4kPoE9rGujapbmRfLQvO4hPIPicyMx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)