UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6W1idFSWmWzCYhkbZ514VRdYoVxTZuCvkXnAs/CEPew='
WHERE
key_id = '3ea04d89bd48e0164ec0314238e1087b4d2bb8f1303a49ffbdc88c500080f340'
AND (
token = '6W1idFSWmWzCYhkbZ514VRdYoVxTZuCvkXnAs/CEPew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)