UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qpwg+i8+ln6HK4n72QMcf4L/6q1mqYeD1dikdIdWBWA='
WHERE
key_id = '522b67ddf12b77a2241548e950c3a2dfdc2bcab01aaabb8c1494f17e5aa48687'
AND (
token = 'qpwg+i8+ln6HK4n72QMcf4L/6q1mqYeD1dikdIdWBWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)