UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXMKp+IihY3QvLvHpQavzvuIkU97hr4oQG2nlLx8oWA='
WHERE
key_id = '5ef22c3c7eb705712ae03c2696b6e69642a5b305214c75fa98832987f2dbdcde'
AND (
token = 'WXMKp+IihY3QvLvHpQavzvuIkU97hr4oQG2nlLx8oWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)